2015-10-13 - 21918.200 - Enhancement - OSA175 - Add the Country in Grouping #CrystalReportsSupport
ENHANCEMENT
21918.200 - OSA175 - Add the Country in Grouping
Requirement Summary
Need to create new group with the Country value in OSA175 Global & Regional reports.
Admin Info
Purpose
|
Need to create new group with the Country value in OSA175 Global & Regional reports.
|
Requested By
|
Jayne Palfreman
|
Spec Created By
|
Dhananjay G
|
Spec Created Date
|
10/13/2015
|
Spec QA by
|
Uday Kumar P
|
Objects
|
OSA175
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
06
|
2
|
Documentation
|
06
|
3
|
Development/ Config
|
40
|
4
|
Unit test in DEV
|
16
|
5
|
BEx & Transports
|
10
|
6
|
Report Formatting & Validation
|
12
|
|
TOTAL
|
90
|
References
Prior Tickets
None
Documents
List of Global and Regional BEx queries that were changed are attached here for reference:
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes,if any
|
1.
|
Create new group with country value as the first grouping in EMEA and second grouping in all other regional & Global versions and
new changes are not effected by default view of all report versions.
|
Mark Harris
|
10/29/2015
|
|
2.
|
Dynamic Group selection for open/delivery indicator.
|
Greg
|
11/03/2015
|
|
3
|
First Ship & Last Ship dates issue at group level.
|
Jayson
|
11/05/2015
|
|
Functional Requirement
Purpose/WHY:
Need to create new group with the country value in OSA175 Global & Regional reports.
In Scope:
OSA175 Global & Regional reports.
Out of Scope:
None
Solution Summary
BEx Query Changes:
1. Need to add navigational country field in all the Global & Regional BEx Queries of OSA175 report.
2. Need to collect the changes into the transport request.
Crystal Changes:
1. Need to create new group in the first grouping for country value i.e Country > Sales Rep > Customer > Period > Doc Number. This grouping will remain the default one for EMEA region only.
2. Need to create new group in the second grouping for country value i.e Country > Sales Rep > Customer > Period > Doc Number for all other regional & Global versions.
3. Need to add new group with country field in the report.
4. Need to update the datasource with newly added query changes in OSA175 Global & Regional reports.
5. Need to validate with BEx queries after completing the development changes.
6. Need to show open/delivery indicators(i.e O,D) based on dynamic group selection for group 5.
7. Need to fix the First Ship & Last Ship date issues at group level in all OSA175 report versions.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Solution Details
BEx Query Changes:
1. Need to add navigational Country field(0SOLD_TO__0COUNTRY) in all the Global & Regional BEx queries of OSA175 report.
2. Need to collect the changes into the transport request.
Crystal Changes:
1. Need to create new group in the first grouping for country value i.e Country > Sales Rep > Customer > Period > Doc Number. This grouping will remain the default one for EMEA region only.
2. Need to create new group in the second grouping for country value i.e Country > Sales Rep > Customer > Period > Doc Number for all other regional & Global versions.
3. Need to add new group with country field(0SOLD_TO__0COUNTRY) in the report.
4. Need to update the datasource with newly add query changes in OSA175 Global & Regional reports.
5. Need to validate with BEx queries after completing the development changes.
6. Need to show open/delivery indicators(i.e O,D) based on dynamic group selection for group 5.
7. Need to fix the First Ship & Last Ship date issues at group level in all OSA175 report versions.
Issues
None
a NEW group with country as the first grouping